package com.ericsson.smart.dto;

import java.io.Serializable;

import javax.persistence.Column;
import javax.persistence.Id;
import javax.persistence.Table;

//@NamedQuery(name = "geographicsDimensionsData",
//query="select g from GeographyDimensionsDTO g where g.area = :area")
// query="select count(g),zip_code from PUBLIC.DIM_GEOGRAPHY g where area="+

@Table(name = "DIM_GEOGRAPHY")
public class GeographyDimension implements Serializable {
	/**
	 * 
	 */
	private static final long serialVersionUID = 1L;

	public GeographyDimension() {
	}

	@Id
	@Column(name = "GEO_ID")
	private String geoId;

	@Column(name = "COUNTRY")
	private String country;

	@Column(name = "STATE")
	private String state;

	@Column(name = "CITY")
	private String city;

	@Column(name = "AREA")
	private String area;

	@Column(name = "SUB_AREA")
	private String subArea;

	@Column(name = "STREET_NAME")
	private String streetName;

	@Column(name = "ZIP_CODE")
	private String zipCode;

	public GeographyDimension(String geoId, String country, String state, String city, String area,
			String subArea, String streetName, String zipCode) {
		this.geoId = geoId;
		this.country = country;
		this.state = state;
		this.city = city;
		this.area = area;
		this.subArea = subArea;
		this.streetName = streetName;
		this.zipCode = zipCode;
	}

	public String getGeoId() {
		return geoId;
	}

	public void setGeoId(String geoId) {
		this.geoId = geoId;
	}

	public String getCountry() {
		return country;
	}

	public void setCountry(String country) {
		this.country = country;
	}

	public String getState() {
		return state;
	}

	public void setState(String state) {
		this.state = state;
	}

	public String getCity() {
		return city;
	}

	public void setCity(String city) {
		this.city = city;
	}

	public String getArea() {
		return area;
	}

	public void setArea(String area) {
		this.area = area;
	}

	public String getSubArea() {
		return subArea;
	}

	public void setSubArea(String subArea) {
		this.subArea = subArea;
	}

	public String getStreetName() {
		return streetName;
	}

	public void setStreetName(String streetName) {
		this.streetName = streetName;
	}

	public String getZipCode() {
		return zipCode;
	}

	public void setZipCode(String zipCode) {
		this.zipCode = zipCode;
	}

}
